How to: Format numbers as currency in a form.
Solution:
In the Form Design view, use the 'Format' property box in the property sheet of the form to format numbers as currency in the form.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Click on the desired control to format.
NOTE: The selected control must have a data type of Number before proceeding.
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Format' tab.
8) Click on the 'Format' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
10) Select 'Currency' from the 'Format' drop-down list.
NOTE: The format for the selected control is set for this form ONLY.
11) Select the 'File' menu and select 'Save' to save the form.
